-- created by kumiler
-- on 2023/1/5 9:21
-- DESC

create external table spmi_dim.dim_spmi_pcp_center_cost_mt
(
	id bigint comment '主键id',
	waybill_month date  comment '运单录入月份',
	send_financial_center_name string  comment '寄件代理区',
	send_financial_center_code string  comment '寄件代理区编码',
	financial_center_name string  comment '转运中心',
	financial_center_code string  comment '转运中心编码',
	ticket_price decimal(12,2)  comment '单票',
	project_code string  comment '项目编码',
	property string  comment '属性',
	create_time timestamp  comment '创建时间'
) COMMENT '单票中心成本'
    PARTITIONED BY (mt string COMMENT '运单录入月份yyyy-MM')
    stored as parquet
    LOCATION '/dw/hive/spmi_dim.db/external/dim_spmi_pcp_center_cost_mt'
;
